Overview

Dataset statistics

Number of variables13
Number of observations2969
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory301.7 KiB
Average record size in memory104.0 B

Variable types

Numeric12
Categorical1

Alerts

products has a high cardinality: 2968 distinct values High cardinality
gross_revenue is highly correlated with qtd_invoices and 4 other fieldsHigh correlation
recency_days is highly correlated with qtd_invoicesHigh correlation
qtd_invoices is highly correlated with gross_revenue and 1 other fieldsHigh correlation
items is highly correlated with gross_revenue and 4 other fieldsHigh correlation
avg_ticket is highly correlated with gross_revenue and 3 other fieldsHigh correlation
avg_recency_days is highly correlated with frequencyHigh correlation
frequency is highly correlated with avg_recency_daysHigh correlation
avg_basket_size is highly correlated with gross_revenue and 3 other fieldsHigh correlation
avg_unique_basket_size is highly correlated with avg_ticketHigh correlation
qtd_returns is highly correlated with gross_revenue and 3 other fieldsHigh correlation
avg_ticket is highly skewed (γ1 = 53.59471816) Skewed
qtd_returns is highly skewed (γ1 = 51.73396344) Skewed
avg_basket_size is highly skewed (γ1 = 45.87296489) Skewed
products is uniformly distributed Uniform
df_index has unique values Unique
customer_id has unique values Unique
recency_days has 34 (1.1%) zeros Zeros
qtd_returns has 1444 (48.6%) zeros Zeros

Reproduction

Analysis started2022-09-10 19:02:15.938466
Analysis finished2022-09-10 19:02:45.016064
Duration29.08 seconds
Software versionpandas-profiling v3.3.0
Download configurationconfig.json

Variables

df_index
Real number (ℝ≥0)

UNIQUE

Distinct2969
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2317.292354
Minimum0
Maximum5715
Zeros1
Zeros (%)< 0.1%
Negative0
Negative (%)0.0%
Memory size23.3 KiB
2022-09-10T16:02:45.092191image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile185.4
Q1929
median2120
Q33537
95-th percentile5035.2
Maximum5715
Range5715
Interquartile range (IQR)2608

Descriptive statistics

Standard deviation1554.944589
Coefficient of variation (CV)0.6710178739
Kurtosis-1.010787014
Mean2317.292354
Median Absolute Deviation (MAD)1271
Skewness0.342284058
Sum6880041
Variance2417852.674
MonotonicityStrictly increasing
2022-09-10T16:02:45.226269image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
01
 
< 0.1%
30111
 
< 0.1%
29961
 
< 0.1%
29991
 
< 0.1%
30001
 
< 0.1%
30011
 
< 0.1%
30021
 
< 0.1%
30051
 
< 0.1%
30071
 
< 0.1%
30081
 
< 0.1%
Other values (2959)2959
99.7%
ValueCountFrequency (%)
01
< 0.1%
11
< 0.1%
21
< 0.1%
31
< 0.1%
41
< 0.1%
51
< 0.1%
61
< 0.1%
71
< 0.1%
81
< 0.1%
91
< 0.1%
ValueCountFrequency (%)
57151
< 0.1%
56961
< 0.1%
56861
< 0.1%
56801
< 0.1%
56591
< 0.1%
56551
< 0.1%
56491
< 0.1%
56381
< 0.1%
56371
< 0.1%
56271
< 0.1%

customer_id
Real number (ℝ≥0)

UNIQUE

Distinct2969
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean15270.77299
Minimum12347
Maximum18287
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size23.3 KiB
2022-09-10T16:02:45.369373image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/

Quantile statistics

Minimum12347
5-th percentile12619.4
Q113799
median15221
Q316768
95-th percentile17964.6
Maximum18287
Range5940
Interquartile range (IQR)2969

Descriptive statistics

Standard deviation1718.990292
Coefficient of variation (CV)0.1125673398
Kurtosis-1.206094692
Mean15270.77299
Median Absolute Deviation (MAD)1488
Skewness0.03160785866
Sum45338925
Variance2954927.624
MonotonicityNot monotonic
2022-09-10T16:02:45.488310image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
178501
 
< 0.1%
175881
 
< 0.1%
149051
 
< 0.1%
161031
 
< 0.1%
146261
 
< 0.1%
148681
 
< 0.1%
182461
 
< 0.1%
171151
 
< 0.1%
166111
 
< 0.1%
159121
 
< 0.1%
Other values (2959)2959
99.7%
ValueCountFrequency (%)
123471
< 0.1%
123481
< 0.1%
123521
< 0.1%
123561
< 0.1%
123581
< 0.1%
123591
< 0.1%
123601
< 0.1%
123621
< 0.1%
123641
< 0.1%
123701
< 0.1%
ValueCountFrequency (%)
182871
< 0.1%
182831
< 0.1%
182821
< 0.1%
182771
< 0.1%
182761
< 0.1%
182741
< 0.1%
182731
< 0.1%
182721
< 0.1%
182701
< 0.1%
182691
< 0.1%

gross_revenue
Real number (ℝ≥0)

HIGH CORRELATION

Distinct2952
Distinct (%)99.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2794.328222
Minimum6.2
Maximum280206.02
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size23.3 KiB
2022-09-10T16:02:45.623491image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/

Quantile statistics

Minimum6.2
5-th percentile231.134
Q1576
median1106.53
Q32338.15
95-th percentile7345.092
Maximum280206.02
Range280199.82
Interquartile range (IQR)1762.15

Descriptive statistics

Standard deviation10662.69409
Coefficient of variation (CV)3.815834522
Kurtosis346.7828136
Mean2794.328222
Median Absolute Deviation (MAD)686.64
Skewness16.58366173
Sum8296360.49
Variance113693045.3
MonotonicityNot monotonic
2022-09-10T16:02:45.741131image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
745.062
 
0.1%
731.92
 
0.1%
2092.322
 
0.1%
1031.412
 
0.1%
657.82
 
0.1%
618.092
 
0.1%
178.962
 
0.1%
1418.032
 
0.1%
3312
 
0.1%
1353.742
 
0.1%
Other values (2942)2949
99.3%
ValueCountFrequency (%)
6.21
< 0.1%
13.31
< 0.1%
151
< 0.1%
36.561
< 0.1%
521
< 0.1%
52.21
< 0.1%
52.21
< 0.1%
62.431
< 0.1%
631
< 0.1%
68.841
< 0.1%
ValueCountFrequency (%)
280206.021
< 0.1%
259657.31
< 0.1%
194550.791
< 0.1%
168472.51
< 0.1%
143813.061
< 0.1%
124914.531
< 0.1%
117375.631
< 0.1%
91062.381
< 0.1%
81024.841
< 0.1%
66653.561
< 0.1%

recency_days
Real number (ℝ≥0)

HIGH CORRELATION
ZEROS

Distinct272
Distinct (%)9.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean64.11350623
Minimum0
Maximum373
Zeros34
Zeros (%)1.1%
Negative0
Negative (%)0.0%
Memory size23.3 KiB
2022-09-10T16:02:45.875135image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile2
Q111
median31
Q381
95-th percentile241.6
Maximum373
Range373
Interquartile range (IQR)70

Descriptive statistics

Standard deviation77.47250784
Coefficient of variation (CV)1.208364858
Kurtosis2.78857133
Mean64.11350623
Median Absolute Deviation (MAD)26
Skewness1.798770397
Sum190353
Variance6001.98947
MonotonicityNot monotonic
2022-09-10T16:02:46.008456image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
199
 
3.3%
487
 
2.9%
285
 
2.9%
385
 
2.9%
876
 
2.6%
1067
 
2.3%
766
 
2.2%
966
 
2.2%
1764
 
2.2%
2255
 
1.9%
Other values (262)2219
74.7%
ValueCountFrequency (%)
034
 
1.1%
199
3.3%
285
2.9%
385
2.9%
487
2.9%
543
1.4%
766
2.2%
876
2.6%
966
2.2%
1067
2.3%
ValueCountFrequency (%)
3732
0.1%
3724
0.1%
3711
 
< 0.1%
3681
 
< 0.1%
3664
0.1%
3652
0.1%
3641
 
< 0.1%
3601
 
< 0.1%
3591
 
< 0.1%
3584
0.1%

qtd_invoices
Real number (ℝ≥0)

HIGH CORRELATION

Distinct59
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean5.756146851
Minimum1
Maximum209
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size23.3 KiB
2022-09-10T16:02:46.156266image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q12
median4
Q36
95-th percentile17
Maximum209
Range208
Interquartile range (IQR)4

Descriptive statistics

Standard deviation8.920686956
Coefficient of variation (CV)1.54976709
Kurtosis193.9643147
Mean5.756146851
Median Absolute Deviation (MAD)2
Skewness10.85129915
Sum17090
Variance79.57865577
MonotonicityNot monotonic
2022-09-10T16:02:46.291222image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2779
26.2%
3504
17.0%
4385
13.0%
5242
 
8.2%
1187
 
6.3%
6172
 
5.8%
7143
 
4.8%
898
 
3.3%
968
 
2.3%
1054
 
1.8%
Other values (49)337
11.4%
ValueCountFrequency (%)
1187
 
6.3%
2779
26.2%
3504
17.0%
4385
13.0%
5242
 
8.2%
6172
 
5.8%
7143
 
4.8%
898
 
3.3%
968
 
2.3%
1054
 
1.8%
ValueCountFrequency (%)
2091
< 0.1%
2011
< 0.1%
1241
< 0.1%
971
< 0.1%
931
< 0.1%
911
< 0.1%
861
< 0.1%
731
< 0.1%
631
< 0.1%
621
< 0.1%

items
Real number (ℝ≥0)

HIGH CORRELATION

Distinct1673
Distinct (%)56.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1609.80229
Minimum1
Maximum196915
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size23.3 KiB
2022-09-10T16:02:46.439437image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile103
Q1298
median641
Q31401
95-th percentile4420
Maximum196915
Range196914
Interquartile range (IQR)1103

Descriptive statistics

Standard deviation5888.984832
Coefficient of variation (CV)3.658203785
Kurtosis465.8189735
Mean1609.80229
Median Absolute Deviation (MAD)422
Skewness17.84256245
Sum4779503
Variance34680142.35
MonotonicityNot monotonic
2022-09-10T16:02:46.596151image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
31010
 
0.3%
8810
 
0.3%
1509
 
0.3%
3009
 
0.3%
3948
 
0.3%
2728
 
0.3%
848
 
0.3%
2887
 
0.2%
2197
 
0.2%
3067
 
0.2%
Other values (1663)2886
97.2%
ValueCountFrequency (%)
11
< 0.1%
22
0.1%
122
0.1%
161
< 0.1%
171
< 0.1%
181
< 0.1%
191
< 0.1%
201
< 0.1%
231
< 0.1%
251
< 0.1%
ValueCountFrequency (%)
1969151
< 0.1%
809971
< 0.1%
799651
< 0.1%
773741
< 0.1%
699931
< 0.1%
645491
< 0.1%
641241
< 0.1%
628121
< 0.1%
582431
< 0.1%
577851
< 0.1%

products
Categorical

HIGH CARDINALITY
UNIFORM

Distinct2968
Distinct (%)> 99.9%
Missing0
Missing (%)0.0%
Memory size23.3 KiB
85123A217332173385123A
 
2
22427224262134022760227702276622788227672282972760B22832824862141122423210802121721844221802250722508215332213822617217182261982484219222260622607226052111582482222962217184968C22180210802075522759227918494523099846092335923108222962184421531215352153921035212172269221524481942309923318229072342423084232412250882484234942343423245233122331423311229102323423353229092260223407214792211121485233552270622141221442311221270221738248323092234092345782494L215332250723374234372337523438234362337321498233492068521523
 
1
230522305022766230532305121654220872267779030G23054230492305123053230502305223054226802268222683221702309222767230522305185123A221897281222676226792309222766230512165485032D84806B2305023052227662309290030A90030C22676226772267823323233272095623052
 
1
232052320185123A2198521212221782131422457229697274185169A211222112421986213858506621714213812249979302M847552241321181219772187021874226522283522112224082277985180B84510A22423227762197421671216722167021669216682208921381222952322720829848792247022670231472222485099F23201223862320021928219294819422469475662245785123A2072323204223562320522314700062240923472235312348423543849922121221985475662242385099B22376215772192821929207132238623201233432335684078A224412216922768219832198423378230848497823173226982269723175226992338223480234892352823529235232352723542223852266323343233442280922810229422294185048849457147723313
 
1
223492230122300227492260622620226072260522998228992290422741227522097722821223842072822728227302296922993229072290522665223842320922273209692097022150221477147721912232292260522570225682311922493209722097122758227542275221935219342238223206207272238322961217912257022569221502214720972209692256422563227412072723209207252266723275221492260721914219152260522693227592256222632226332343922866228652286723493235042350322940221422214122144217312308422554225552255722568209692097020972209712263222633234392286622865228672211222835232092319822666231582294023082230832310023267233892348023084225682262120969209702349323494233552211422835221123597023100230832191422865228672255622554225572349323480217312308422112228352335523083
 
1
Other values (2963)
2963 

Length

Max length39939
Median length1478
Mean length625.1966992
Min length5

Characters and Unicode

Total characters1856209
Distinct characters34
Distinct categories3 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique2967 ?
Unique (%)99.9%

Sample

1st row85123A7105384406B84029G84029E22752217302263322632226322263385123A7105384406B206793737021871210712106882483824868248282494L84029G84029E227522173085123A7105384406B206793737021871210712106882483824868248282494L84029G84029E2275221730226322263385123A7105384406B15056BL206793737021871210712106882483824868248282494L84029G84029E227522280321730226322263385123A7105384406B206793737021871210712106882483824868248282494L84029G84029E227522280321730226322263385123A7105382483824868248282494L2241184029G84029E227522280321730226322263337370218712107121068824832241184029G84029E217302275285123A71053226322263385123A7105384406B3737021871210712106882483824868248282494L2241184029G84029E2275221730226322263385123A7105384406B3737021871210712106882483824868248282494L2241184029G84029E21730226322263385123A7105384406B3737021871210712106882483824868248282494L2241184029G84029E2275221730226322263385123A7105384406B3737021871210712106882483824868248282494L2241184029G84029E2275221730226322263384029E22752228032173085123A7105384406B3737021871210712106882483824868248282494L2241184029G226322263385123A7105384406B3737021871210712106882483824868248282494L2241184029G84029E227522280321730226322263385123A7105384406B15056BL206793737021871210712106882483824868248282494L2241184029G84029E227522280321730226322263385123A7105384406B15056BL206793737021871210712106882483824868248282494L2241184029G84029E227522280321730226322263385123A7105384406B373702187121071210688248282494L84029G84029E2275221730226332263285123A7105384406B15056BL2067937370210712106882483824868248282494L84029G84029E2275222803217302263222633
2nd row848792274522748227492231084969226232262221754217552177748187229602291322912229142175616161P227662270823231850158501622829227222296022961229692272022549209722274384969226222165821756217542175548184226922274822745227492296022722227202097222274849692262322499226072165847566217562175421755219022190121899219002207785123A2315223182231612316023163231622316423177231762300622996230702312623299849692165822423475662162123092231122311023111231182309323089231682323623240231752317323245230322303123029230288505322090220892208885123A217554756622423849692312620972227202315223162231632262316161P21754217552190121900481872311223111231102309323028232452324023173232362318223161231602296023546235452323122720227082298622739234352296022722227202097222621481884818448187230322303185053232452289922367235142351323511231982329423295230252347023397230962348723109234342208685049EM
3rd row22728227272272621724218831000221791210352232622629226592263122661217312290021913225402254422492POST210862108022726227272272822729211212232620750225512255622555217312239022333223312071921883210422236721094POST225402253922556225542255121981226152261622614162182232622492POST2300723010215592104221080210862109421240217312233322331225562255422729221972209022492POST229912300923280232812255622492224342124021238220902272920724207192103921121212122115420983209812124584380POST23100212402123821244212422329822197212102235622466226102260922561POST2272622727227282272916218231242109421080210862155922333POST22728210802109421086229552263622556359702198821989219872255422551POST22081220822208021210211562108021086210942344522326POST2316922326224922103921210226592272622727227282233322466233282338823389233902337323374229912173122778POST221972336823367235062350922629215592115620750220902329822539POST233892235223389233882339022197POST207242348023570233672255522951224172197620719207242235622492226362219722083223262232821207227272272622728227302344523298POST2121223367233682233322991210942108621080219882198921987216802233223598POST230842356222540225442348023084232982290922613226172351522367POST21156223522155922326233882272822726
4th row22086228432284122839224232290722961225852208422423212322245722084233782312922423220772295023351233502331923354220868494622734229522301323012
5th row212582125821258

Common Values

ValueCountFrequency (%)
85123A217332173385123A2
 
0.1%
22427224262134022760227702276622788227672282972760B22832824862141122423210802121721844221802250722508215332213822617217182261982484219222260622607226052111582482222962217184968C22180210802075522759227918494523099846092335923108222962184421531215352153921035212172269221524481942309923318229072342423084232412250882484234942343423245233122331423311229102323423353229092260223407214792211121485233552270622141221442311221270221738248323092234092345782494L2153322507233742343723375234382343623373214982334920685215231
 
< 0.1%
230522305022766230532305121654220872267779030G23054230492305123053230502305223054226802268222683221702309222767230522305185123A221897281222676226792309222766230512165485032D84806B2305023052227662309290030A90030C226762267722678233232332720956230521
 
< 0.1%
232052320185123A2198521212221782131422457229697274185169A211222112421986213858506621714213812249979302M847552241321181219772187021874226522283522112224082277985180B84510A22423227762197421671216722167021669216682208921381222952322720829848792247022670231472222485099F23201223862320021928219294819422469475662245785123A2072323204223562320522314700062240923472235312348423543849922121221985475662242385099B22376215772192821929207132238623201233432335684078A2244122169227682198321984233782308484978231732269822697231752269923382234802348923528235292352323527235422238522663233432334422809228102294222941850488494571477233131
 
< 0.1%
2234922301223002274922606226202260722605229982289922904227412275220977228212238420728227282273022969229932290722905226652238423209222732096920970221502214771477219122322922605225702256823119224932097220971227582275422752219352193422382232062072722383229612179122570225692215022147209722096922564225632274120727232092072522667232752214922607219142191522605226932275922562226322263323439228662286522867234932350423503229402214222141221442173123084225542255522557225682096920970209722097122632226332343922866228652286722112228352320923198226662315822940230822308323100232672338923480230842256822621209692097023493234942335522114228352211235970231002308321914228652286722556225542255723493234802173123084221122283523355230831
 
< 0.1%
710532208722087213401
 
< 0.1%
2250122776213404813871459847552242722844224234756622382223842238685099C2072585099B229072129423173226992317023245227202238422386224234756685123A2324323174231752243023582223868248690058B85099C23344900571
 
< 0.1%
217032304823044209722274922568227512304323044230911
 
< 0.1%
84993A8437817107D2230084993B84595E22964474712082921696217132171484804A2307884536B214993744947559B374481
 
< 0.1%
2072522254222552075085014B20682227402320622352226292265922631223822103522895215592290022556225512230321936POST231902319123192232062072521936223522274022328229702230323084POST85014A218832188121880229912299222561223822235221559230842173121452230792072520726226592262922631232062344585014BPOST23084234802335023351233492335322952219762074920750223262255422551225562177022976229642296622992POST23084217312255622555233512334923480229662230322302231152335222328POST1
 
< 0.1%
Other values (2958)2958
99.6%

Length

2022-09-10T16:02:46.788157image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
charges6
 
0.2%
85123a217332173385123a2
 
0.1%
2166822771228052277222774227732277122775228052277322772227712277522772227742277222774228052277522771m217138517484927f84927a84927d208867212272128721278463822796721302171417091a17091j230762156121559224322243122433230772296985036c85036b72803a85036a2243672802a85036a72807c72807b8463120961209632260623128226982269922697224232246122771216692167321672216712166821794217932277621672216682277522773227722277422771228052167321669216702303223028230312302923033230342303522771227732277221669216682167322774227712167021669227752277222772227752277122773216722166821673216712166923032230292303123033230342303521670216682167122775227722166923033230282280521669230322277122775216702166822775227712166821672216702166922771227752256022489228052277221670216732166821671227752280521672227712166922771216712303221668216722277522774230282302921672230332166823028230342166922772227752280521669227732167323033227752277122773216722167021671216682166923035230322303422771227742277522773216732167121670216722303321669851752166823034230282332023319230322277422771216702166922775227721
 
< 0.1%
22297227712277222773228052246922197211252112685049c85049d85049e85049g21061210632106284380843782296421213224172121284992219752238320728207272229620728207252072722383223842123222646223182072720728223832238423209207252264622645212312123223089231472314682486221972265022644224692219722469207272072822383232092193185099c2320385099b2192821929824868248385130b85130c20725223842358323301223832320922469226502219723096234522345322297207251
 
< 0.1%
2211022098221002276622451225498474485049e213282296117091a2247384509a84510a22767227682146321464208208515022117211694812982580825788258122413219072244121122228518499122810228092243520966209632096122068217432174484709b2159221587209922266285123a228048248320749207252238220726223842246784625c84625a21108228482103347570b84030e22428225021621884559b84559a22437224368522722983220302119921829212942233222181222712227421989230532305216259475662329821034223542132640001851072332223321233332333423332224602298323109230822103423177851771623621703210982299723501235042350222621227552183223188230842207485049c1622585123a2214422910207582343423435233112340622766227282335282616c23044224912339523393233942278523569235702357184029g21479233192331884012235312278123486210341
 
< 0.1%
22728227272272621724218831000221791210352232622629226592263122661217312290021913225402254422492post210862108022726227272272822729211212232620750225512255622555217312239022333223312071921883210422236721094post225402253922556225542255121981226152261622614162182232622492post2300723010215592104221080210862109421240217312233322331225562255422729221972209022492post229912300923280232812255622492224342124021238220902272920724207192103921121212122115420983209812124584380post23100212402123821244212422329822197212102235622466226102260922561post2272622727227282272916218231242109421080210862155922333post22728210802109421086229552263622556359702198821989219872255422551post22081220822208021210211562108021086210942344522326post2316922326224922103921210226592272622727227282233322466233282338823389233902337323374229912173122778post221972336823367235062350922629215592115620750220902329822539post233892235223389233882339022197post207242348023570233672255522951224172197620719207242235622492226362219722083223262232821207227272272622728227302344523298post2121223367233682233322991210942108621080219882198921987216802233223598post230842356222540225442348023084232982290922613226172351522367post211562235221559223262338822728227261
 
< 0.1%
220862284322841228392242322907229612258522084224232123222457220842337823129224232207722950233512335023319233542208684946227342295223013230121
 
< 0.1%
2125821258212581
 
< 0.1%
22114217338248482486217542242422505227682175421755217562217084406b8487921136850662279622294224874818848194206858475521621216232296822759227622175648188824862224122288m48185215242242482486222192217084406b221732218948138481942152448111212322125984970l22855222122224121756206858248646000s222198487922189228222152348188847557147784970l227842167321672216692166822844228522284522853481848248621672217542175521668216692167021755216702166921668225782257922577215244818821733217542175522112225772257822579227842221222219233551
 
< 0.1%
2238685099c210332072384997b84997c210942072521559223522121221975219778499184519a85183b85071b219312192922343223452234484519a48188223792238185099b2108021086219758499221210219742266784519b212162193521934219002191184849d2096671496b71495b2186521867219012186647310m218642186722090793212238122379219754811148173c2237921934223802235621900219012190222197207232072420719223552299622995229982299779302m7932147310m2237922381223802209021212461182193221937206752067621901219252193421935216212205348111223862072377101a2235677101a2143046126a2123921240212382124277101a22197210942198979321221792295320724223554611821937219362117248188231822318221034223812237948188219342197479026b22997229952189921900219022190123182219362123821866218642186521867217702117220676206772067579051a47310m2217922995229972318247310m220908482823298793212238023204229532193422356216212116521936211722235523205231822190282551825522267447310m22090793212193521934219372193621936219312238623199229532071923204217702320523182825512299622355223562177023199232012237979321215592072721930219342238685099b210332238622995229982238420728231822318222197211622116323321230802193021931223862320185099c85099f85099b231992238021934219352071920723223552320522356232042072420727207252238447310m21430793212117223321219012190021899219022295322997215582177022379219348255121935207112237921770231824611822995224672334822138217702299647310m2142722674221382261722379223812334820711221382334822467223812348523328217422246722467217702330120728231692358316258a8255221949231942324147310m23471218992190021901235011623621832162372355220986235712249123126231272227422475221912098285135c85136a22997221382143023192231822175421756219302358122381223791
 
< 0.1%
Other values (2964)2964
99.5%

Most occurring characters

ValueCountFrequency (%)
2568777
30.6%
1193850
 
10.4%
3182049
 
9.8%
8140316
 
7.6%
9133911
 
7.2%
0129867
 
7.0%
4125320
 
6.8%
7121703
 
6.6%
5121128
 
6.5%
6104084
 
5.6%
Other values (24)35204
 
1.9%

Most occurring categories

ValueCountFrequency (%)
Decimal Number1821005
98.1%
Uppercase Letter35193
 
1.9%
Space Separator11
 
< 0.1%

Most frequent character per category

Uppercase Letter
ValueCountFrequency (%)
B8451
24.0%
A7546
21.4%
C3827
10.9%
S2173
 
6.2%
D2117
 
6.0%
L1834
 
5.2%
P1578
 
4.5%
E1419
 
4.0%
F1252
 
3.6%
T1033
 
2.9%
Other values (13)3963
11.3%
Decimal Number
ValueCountFrequency (%)
2568777
31.2%
1193850
 
10.6%
3182049
 
10.0%
8140316
 
7.7%
9133911
 
7.4%
0129867
 
7.1%
4125320
 
6.9%
7121703
 
6.7%
5121128
 
6.7%
6104084
 
5.7%
Space Separator
ValueCountFrequency (%)
11
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common1821016
98.1%
Latin35193
 
1.9%

Most frequent character per script

Latin
ValueCountFrequency (%)
B8451
24.0%
A7546
21.4%
C3827
10.9%
S2173
 
6.2%
D2117
 
6.0%
L1834
 
5.2%
P1578
 
4.5%
E1419
 
4.0%
F1252
 
3.6%
T1033
 
2.9%
Other values (13)3963
11.3%
Common
ValueCountFrequency (%)
2568777
31.2%
1193850
 
10.6%
3182049
 
10.0%
8140316
 
7.7%
9133911
 
7.4%
0129867
 
7.1%
4125320
 
6.9%
7121703
 
6.7%
5121128
 
6.7%
6104084
 
5.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII1856209
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2568777
30.6%
1193850
 
10.4%
3182049
 
9.8%
8140316
 
7.6%
9133911
 
7.2%
0129867
 
7.0%
4125320
 
6.8%
7121703
 
6.6%
5121128
 
6.5%
6104084
 
5.6%
Other values (24)35204
 
1.9%

avg_ticket
Real number (ℝ≥0)

HIGH CORRELATION
SKEWED

Distinct2965
Distinct (%)99.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean51.61729517
Minimum2.150588235
Maximum56157.5
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size23.3 KiB
2022-09-10T16:02:46.988096image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/

Quantile statistics

Minimum2.150588235
5-th percentile4.929011742
Q113.16661017
median18.18108696
Q325.31482759
95-th percentile90.66859318
Maximum56157.5
Range56155.34941
Interquartile range (IQR)12.14821742

Descriptive statistics

Standard deviation1035.921865
Coefficient of variation (CV)20.06927836
Kurtosis2902.070996
Mean51.61729517
Median Absolute Deviation (MAD)6.130240562
Skewness53.59471816
Sum153251.7494
Variance1073134.11
MonotonicityNot monotonic
2022-09-10T16:02:47.222665image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
16.833333332
 
0.1%
152
 
0.1%
4.1622
 
0.1%
14.478333332
 
0.1%
18.152222221
 
< 0.1%
12.9491
 
< 0.1%
16.293720931
 
< 0.1%
36.244117651
 
< 0.1%
29.784166671
 
< 0.1%
22.87926231
 
< 0.1%
Other values (2955)2955
99.5%
ValueCountFrequency (%)
2.1505882351
< 0.1%
2.43251
< 0.1%
2.4623711341
< 0.1%
2.5048760331
< 0.1%
2.508371561
< 0.1%
2.651
< 0.1%
2.6569318181
< 0.1%
2.7075982531
< 0.1%
2.7606215721
< 0.1%
2.7710052911
< 0.1%
ValueCountFrequency (%)
56157.51
< 0.1%
4453.431
< 0.1%
2027.861
< 0.1%
1687.21
< 0.1%
952.98751
< 0.1%
872.131
< 0.1%
835.8641
< 0.1%
643.85857141
< 0.1%
6401
< 0.1%
624.41
< 0.1%

avg_recency_days
Real number (ℝ≥0)

HIGH CORRELATION

Distinct1258
Distinct (%)42.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean67.35143043
Minimum1
Maximum366
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size23.3 KiB
2022-09-10T16:02:47.388170image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile8
Q125.92857143
median48.28571429
Q385.33333333
95-th percentile201
Maximum366
Range365
Interquartile range (IQR)59.4047619

Descriptive statistics

Standard deviation63.54282948
Coefficient of variation (CV)0.9434518178
Kurtosis4.887703174
Mean67.35143043
Median Absolute Deviation (MAD)26.28571429
Skewness2.062908983
Sum199966.397
Variance4037.691178
MonotonicityNot monotonic
2022-09-10T16:02:47.685190image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1425
 
0.8%
422
 
0.7%
7021
 
0.7%
720
 
0.7%
3519
 
0.6%
4918
 
0.6%
2117
 
0.6%
4617
 
0.6%
1117
 
0.6%
116
 
0.5%
Other values (1248)2777
93.5%
ValueCountFrequency (%)
116
0.5%
1.51
 
< 0.1%
213
0.4%
2.51
 
< 0.1%
2.6013986011
 
< 0.1%
315
0.5%
3.3214285711
 
< 0.1%
3.3303571431
 
< 0.1%
3.52
 
0.1%
422
0.7%
ValueCountFrequency (%)
3661
 
< 0.1%
3651
 
< 0.1%
3631
 
< 0.1%
3621
 
< 0.1%
3572
0.1%
3561
 
< 0.1%
3552
0.1%
3521
 
< 0.1%
3512
0.1%
3503
0.1%

frequency
Real number (ℝ≥0)

HIGH CORRELATION

Distinct1350
Distinct (%)45.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.06327172298
Minimum0.005449591281
Maximum3
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size23.3 KiB
2022-09-10T16:02:47.970471image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/

Quantile statistics

Minimum0.005449591281
5-th percentile0.009433962264
Q10.01777777778
median0.02941176471
Q30.05540166205
95-th percentile0.2222222222
Maximum3
Range2.994550409
Interquartile range (IQR)0.03762388427

Descriptive statistics

Standard deviation0.1344819335
Coefficient of variation (CV)2.125466593
Kurtosis121.5596918
Mean0.06327172298
Median Absolute Deviation (MAD)0.01433823529
Skewness8.773426515
Sum187.8537455
Variance0.01808539044
MonotonicityNot monotonic
2022-09-10T16:02:48.265062image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.166666666721
 
0.7%
0.333333333321
 
0.7%
0.0277777777820
 
0.7%
0.0909090909119
 
0.6%
0.062517
 
0.6%
0.133333333316
 
0.5%
0.416
 
0.5%
0.2515
 
0.5%
0.0238095238115
 
0.5%
0.0357142857115
 
0.5%
Other values (1340)2794
94.1%
ValueCountFrequency (%)
0.0054495912811
 
< 0.1%
0.0054644808741
 
< 0.1%
0.0054945054951
 
< 0.1%
0.0055096418731
 
< 0.1%
0.0055865921792
0.1%
0.0056022408961
 
< 0.1%
0.0056179775282
0.1%
0.005665722381
 
< 0.1%
0.0056818181822
0.1%
0.0056980056983
0.1%
ValueCountFrequency (%)
31
 
< 0.1%
21
 
< 0.1%
1.5714285711
 
< 0.1%
1.53
 
0.1%
114
0.5%
0.83333333331
 
< 0.1%
0.751
 
< 0.1%
0.666666666712
0.4%
0.65147453081
 
< 0.1%
0.61
 
< 0.1%

qtd_returns
Real number (ℝ≥0)

HIGH CORRELATION
SKEWED
ZEROS

Distinct216
Distinct (%)7.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean63.12428427
Minimum0
Maximum80995
Zeros1444
Zeros (%)48.6%
Negative0
Negative (%)0.0%
Memory size23.3 KiB
2022-09-10T16:02:48.603252image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median1
Q39
95-th percentile103.6
Maximum80995
Range80995
Interquartile range (IQR)9

Descriptive statistics

Standard deviation1513.12627
Coefficient of variation (CV)23.97058893
Kurtosis2760.800218
Mean63.12428427
Median Absolute Deviation (MAD)1
Skewness51.73396344
Sum187416
Variance2289551.108
MonotonicityNot monotonic
2022-09-10T16:02:48.947293image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
01444
48.6%
1177
 
6.0%
2153
 
5.2%
3107
 
3.6%
490
 
3.0%
672
 
2.4%
564
 
2.2%
849
 
1.7%
1248
 
1.6%
747
 
1.6%
Other values (206)718
24.2%
ValueCountFrequency (%)
01444
48.6%
1177
 
6.0%
2153
 
5.2%
3107
 
3.6%
490
 
3.0%
564
 
2.2%
672
 
2.4%
747
 
1.6%
849
 
1.7%
938
 
1.3%
ValueCountFrequency (%)
809951
< 0.1%
90141
< 0.1%
80601
< 0.1%
46271
< 0.1%
37681
< 0.1%
33351
< 0.1%
29751
< 0.1%
20221
< 0.1%
20121
< 0.1%
19201
< 0.1%

avg_basket_size
Real number (ℝ≥0)

HIGH CORRELATION
SKEWED

Distinct1968
Distinct (%)66.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean245.9893671
Minimum1
Maximum40498.5
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size23.3 KiB
2022-09-10T16:02:49.897264image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile44
Q1103.2
median172
Q3279.8
95-th percentile597.8
Maximum40498.5
Range40497.5
Interquartile range (IQR)176.6

Descriptive statistics

Standard deviation784.142945
Coefficient of variation (CV)3.18771073
Kurtosis2342.591386
Mean245.9893671
Median Absolute Deviation (MAD)82
Skewness45.87296489
Sum730342.431
Variance614880.1582
MonotonicityNot monotonic
2022-09-10T16:02:50.084202image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
10011
 
0.4%
11410
 
0.3%
8210
 
0.3%
1908
 
0.3%
738
 
0.3%
1368
 
0.3%
868
 
0.3%
608
 
0.3%
757
 
0.2%
2887
 
0.2%
Other values (1958)2884
97.1%
ValueCountFrequency (%)
12
0.1%
21
< 0.1%
3.3333333331
< 0.1%
5.3333333331
< 0.1%
5.6666666671
< 0.1%
6.1428571431
< 0.1%
7.51
< 0.1%
91
< 0.1%
9.51
< 0.1%
111
< 0.1%
ValueCountFrequency (%)
40498.51
< 0.1%
6009.3333331
< 0.1%
3684.476191
< 0.1%
28801
< 0.1%
2697.4657531
< 0.1%
2183.21
< 0.1%
2160.3333331
< 0.1%
2141.51
< 0.1%
2082.2258061
< 0.1%
20001
< 0.1%

avg_unique_basket_size
Real number (ℝ≥0)

HIGH CORRELATION

Distinct1015
Distinct (%)34.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean22.04850801
Minimum1
Maximum300.6470588
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size23.3 KiB
2022-09-10T16:02:50.217536image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile3.5
Q110.09090909
median17.25
Q327.71428571
95-th percentile56.7030303
Maximum300.6470588
Range299.6470588
Interquartile range (IQR)17.62337662

Descriptive statistics

Standard deviation18.95331893
Coefficient of variation (CV)0.8596191143
Kurtosis23.52827499
Mean22.04850801
Median Absolute Deviation (MAD)8.25
Skewness3.175447774
Sum65462.02028
Variance359.2282983
MonotonicityNot monotonic
2022-09-10T16:02:50.340063image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1354
 
1.8%
1444
 
1.5%
1135
 
1.2%
932
 
1.1%
2031
 
1.0%
131
 
1.0%
1028
 
0.9%
1727
 
0.9%
17.527
 
0.9%
1527
 
0.9%
Other values (1005)2633
88.7%
ValueCountFrequency (%)
131
1.0%
1.21
 
< 0.1%
1.251
 
< 0.1%
1.3333333332
 
0.1%
1.59
 
0.3%
1.5555555561
 
< 0.1%
1.5714285711
 
< 0.1%
1.6666666674
 
0.1%
1.8333333331
 
< 0.1%
1.91
 
< 0.1%
ValueCountFrequency (%)
300.64705881
< 0.1%
203.51
< 0.1%
1491
< 0.1%
145.33333331
< 0.1%
136.251
< 0.1%
135.751
< 0.1%
1271
< 0.1%
1221
< 0.1%
1181
< 0.1%
1141
< 0.1%

Interactions

2022-09-10T16:02:42.649019image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:20.750259image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:22.975424image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:24.890218image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:26.498127image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:28.946549image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:30.295329image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:31.989203image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:34.561977image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:36.805378image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:38.828271image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:40.371126image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:42.873147image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:20.980641image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:23.083947image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:25.014494image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:26.721445image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:29.053278image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:30.430621image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:32.106954image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:34.799215image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:36.926152image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:38.963957image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:40.492425image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:43.098729image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:21.197524image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:23.203398image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:25.138048image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:26.943468image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:29.162296image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:30.574523image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:32.226341image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:35.038073image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:37.044159image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:39.081300image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:40.612170image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:43.326310image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:21.421225image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:23.326566image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:25.266084image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:27.162701image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:29.274412image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:30.717265image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:32.344022image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:35.261752image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:37.177327image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:39.201994image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:40.730288image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:43.558430image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:21.676909image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:23.457307image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:25.399041image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:27.399295image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:29.388458image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:30.881202image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:32.503229image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:35.494290image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:37.297560image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:39.333299image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:40.865357image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:43.761291image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:21.910289image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:23.561544image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:25.510247image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:27.611659image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:29.489336image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:31.023067image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:32.708128image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:35.709348image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:37.410617image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:39.451074image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:40.991068image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:43.878110image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:22.146468image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:23.694218image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:25.633078image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:27.853539image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:29.604249image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:31.185072image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:32.991603image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:35.951804image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:37.534225image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:39.583884image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:41.169386image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:43.992438image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:22.397252image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:23.807095image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:25.740572image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:28.075534image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:29.713118image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:31.320454image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:33.219374image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:36.180010image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:38.244147image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:39.708223image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:41.365206image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:44.118129image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:22.524262image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:23.934844image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:25.857208image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:28.307002image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:29.836291image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:31.452156image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:33.479185image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:36.314947image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:38.360557image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:39.839161image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:41.609359image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:44.230126image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:22.631199image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:24.550073image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:25.970253image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:28.530445image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:29.947575image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:31.574956image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:33.709026image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:36.427389image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:38.467545image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:39.968407image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:41.871492image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:44.358461image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:22.743739image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:24.661158image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:26.095270image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:28.722176image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:30.066038image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:31.706156image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:33.999961image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:36.555038image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:38.585096image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:40.098516image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:42.126147image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:44.484508image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:22.863292image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:24.778580image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:26.277395image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:28.836215image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:30.183142image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:31.844189image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:34.325256image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:36.683500image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:38.715676image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:40.243201image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-09-10T16:02:42.413472image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/

Correlations

2022-09-10T16:02:50.454499image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
2022-09-10T16:02:50.625160image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
2022-09-10T16:02:50.796741image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
2022-09-10T16:02:50.984357image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Missing values

2022-09-10T16:02:44.684306image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
A simple visualization of nullity by column.
2022-09-10T16:02:44.922966image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

First rows

df_indexcustomer_idgross_revenuerecency_daysqtd_invoicesitemsproductsavg_ticketavg_recency_daysfrequencyqtd_returnsavg_basket_sizeavg_unique_basket_size
00178505391.21372.034.01733.085123A7105384406B84029G84029E22752217302263322632226322263385123A7105384406B206793737021871210712106882483824868248282494L84029G84029E227522173085123A7105384406B206793737021871210712106882483824868248282494L84029G84029E2275221730226322263385123A7105384406B15056BL206793737021871210712106882483824868248282494L84029G84029E227522280321730226322263385123A7105384406B206793737021871210712106882483824868248282494L84029G84029E227522280321730226322263385123A7105382483824868248282494L2241184029G84029E227522280321730226322263337370218712107121068824832241184029G84029E217302275285123A71053226322263385123A7105384406B3737021871210712106882483824868248282494L2241184029G84029E2275221730226322263385123A7105384406B3737021871210712106882483824868248282494L2241184029G84029E21730226322263385123A7105384406B3737021871210712106882483824868248282494L2241184029G84029E2275221730226322263385123A7105384406B3737021871210712106882483824868248282494L2241184029G84029E2275221730226322263384029E22752228032173085123A7105384406B3737021871210712106882483824868248282494L2241184029G226322263385123A7105384406B3737021871210712106882483824868248282494L2241184029G84029E227522280321730226322263385123A7105384406B15056BL206793737021871210712106882483824868248282494L2241184029G84029E227522280321730226322263385123A7105384406B15056BL206793737021871210712106882483824868248282494L2241184029G84029E227522280321730226322263385123A7105384406B373702187121071210688248282494L84029G84029E2275221730226332263285123A7105384406B15056BL2067937370210712106882483824868248282494L84029G84029E227522280321730226322263318.15222235.5000000.48611140.050.9705888.735294
11130473237.5431.010.01391.0848792274522748227492231084969226232262221754217552177748187229602291322912229142175616161P227662270823231850158501622829227222296022961229692272022549209722274384969226222165821756217542175548184226922274822745227492296022722227202097222274849692262322499226072165847566217562175421755219022190121899219002207785123A2315223182231612316023163231622316423177231762300622996230702312623299849692165822423475662162123092231122311023111231182309323089231682323623240231752317323245230322303123029230288505322090220892208885123A217554756622423849692312620972227202315223162231632262316161P21754217552190121900481872311223111231102309323028232452324023173232362318223161231602296023546235452323122720227082298622739234352296022722227202097222621481884818448187230322303185053232452289922367235142351323511231982329423295230252347023397230962348723109234342208685049EM18.82290727.2500000.04878036.0139.10000017.200000
22125837281.382.015.05060.022728227272272621724218831000221791210352232622629226592263122661217312290021913225402254422492POST210862108022726227272272822729211212232620750225512255622555217312239022333223312071921883210422236721094POST225402253922556225542255121981226152261622614162182232622492POST2300723010215592104221080210862109421240217312233322331225562255422729221972209022492POST229912300923280232812255622492224342124021238220902272920724207192103921121212122115420983209812124584380POST23100212402123821244212422329822197212102235622466226102260922561POST2272622727227282272916218231242109421080210862155922333POST22728210802109421086229552263622556359702198821989219872255422551POST22081220822208021210211562108021086210942344522326POST2316922326224922103921210226592272622727227282233322466233282338823389233902337323374229912173122778POST221972336823367235062350922629215592115620750220902329822539POST233892235223389233882339022197POST207242348023570233672255522951224172197620719207242235622492226362219722083223262232821207227272272622728227302344523298POST2121223367233682233322991210942108621080219882198921987216802233223598POST230842356222540225442348023084232982290922613226172351522367POST2115622352215592232623388227282272629.47927123.1875000.04569951.0337.33333316.466667
3313748948.2595.05.0439.02208622843228412283922423229072296122585220842242321232224572208423378231292242322077229502335123350233192335422086849462273422952230132301233.86607192.6666670.0179210.087.8000005.600000
4415100876.00333.03.080.0212582125821258292.0000008.6000000.13636422.026.6666671.000000
55152914668.3025.015.02103.022114217338248482486217542242422505227682175421755217562217084406B8487921136850662279622294224874818848194206858475521621216232296822759227622175648188824862224122288M48185215242242482486222192217084406B221732218948138481942152448111212322125984970L22855222122224121756206858248646000S222198487922189228222152348188847557147784970L2278421673216722166921668228442285222845228534818482486216722175421755216682166921670217552167021669216682257822579225772152448188217332175421755221122257722578225792278422212222192335545.32330123.2000000.05444129.0140.2000006.866667
66146885630.877.021.03621.02238685099C210332072384997B84997C210942072521559223522121221975219778499184519A85183B85071B219312192922343223452234484519A48188223792238185099B2108021086219758499221210219742266784519B212162193521934219002191184849D2096671496B71495B2186521867219012186647310M218642186722090793212238122379219754811148173C2237921934223802235621900219012190222197207232072420719223552299622995229982299779302M7932147310M2237922381223802209021212461182193221937206752067621901219252193421935216212205348111223862072377101A2235677101A2143046126A2123921240212382124277101A22197210942198979321221792295320724223554611821937219362117248188231822318221034223812237948188219342197479026B22997229952189921900219022190123182219362123821866218642186521867217702117220676206772067579051A47310M2217922995229972318247310M220908482823298793212238023204229532193422356216212116521936211722235523205231822190282551825522267447310M22090793212193521934219372193621936219312238623199229532071923204217702320523182825512299622355223562177023199232012237979321215592072721930219342238685099B210332238622995229982238420728231822318222197211622116323321230802193021931223862320185099C85099F85099B231992238021934219352071920723223552320522356232042072420727207252238447310M21430793212117223321219012190021899219022295322997215582177022379219348255121935207112237921770231824611822995224672334822138217702299647310M2142722674221382261722379223812334820711221382334822467223812348523328217422246722467217702330120728231692358316258A8255221949231942324147310M23471218992190021901235011623621832162372355220986235712249123126231272227422475221912098285135C85136A229972213821430231922318221754217562193023581223812237917.21978618.3000000.073569399.0172.42857115.571429
77178095411.9116.012.02057.0229612294322617225692256884032B84032A22749229402290922652229102258521523226242152322624481382328423298229882236621463214642233421034223331012016235224392191421220213292097421829232842338222909229502291022141221422331222585229612256123188229912299223192846922330084347843472330023188221422214123298223662330088.71983635.7000000.03910642.0171.4166675.083333
881531160767.900.091.038194.0221398485422411825672167222774227717127022262226372193421169211662117537444A37444C220862208384971S7127047580222618483222644215332155715056BL15056N226462217622438217312277822719215232262022778849462103384865211722150484563A84563B2250221867216722167337444A2277585035B22775843782263722891218992208382613B82599211582208685014A374462235521258793213744935004C84559B84997D4758084415B2065522170206772123922088220902090622262221752217621243220832109837444B2193422646373332121221872212598486584997D22086226208497884050212582290984997D84997C212442067521240215592289184946226444758021470227882276622261222622156372598225028248615056BL7932135004C82494L225022082922778228442264421731228452173185184C227742290922910824864000115056N228342075022788208292177421231207192072685035B793212080248173C2075082567848362167084849D229092284522746225632256222756219492124321245206772067484997D84997C84997B826002272321832223132244585136A7932148111222422271985099B35004C21668793212208721258221982217184997D84997C824838248615056BL84563A22891215592156121558223522165884509A2173121169223842209047580217732252385036A21988219892089782613C21899848322138021670216692167121672216732226221445214472143920675826002075020829223252156321564211212277521380222412177437449217732237821240212382106884970L84970S84989A2115521243212442124522909206752067422620207332112175049L8475521672216718248484947849468515284997C84997A84997D228052277121931223558248485099F2117582599207252072722384207282071920718207242067720675206742067684997B212422210384993A21244212432124521240212392123820676212122277422775227732277222845228442257182001S207272271921774218818248221754211642280521242206762108021212212388483621121218442264584970S15056N215582103521041475802075420718207242235615056N35004C79321227782284521658843782067622352216712167321669216702167284997D84997C2072521240210682123121210210802198921242212442124521243211232175485099F2071321930219282241121934217732072521668227742167021669216712167321754218992124321244220888259984997B84997D84997C84997A84509A84510A222622184472799F206752067720674206762156185099C85099F2071922356217312284437448221972206185232A2241184520B22088215592155884997C2165822494212442124521033215592156121558206752175485099B84997B84997D2217572760B2112222494215632156484997C84997A216732167221671216702166922774217312193415056N224942247021329213282132722262227752277421669216702290822908219892250279321215232208784509C84946213132067915056N222622217084970S22171474214742222470213272263722325227882082922313217332252185032B2138085019A2186721867214392289185163B1601621755848652155785167B848322211247559B4758021035848368437821658219472194921899215632156417136A2112121122206653733321166211698258182567825832227822276211632115984912B214702146784849D84971S84997C84997A2208922090220882075084596B84596F22176216732116421987219892068522646207282210321564217332112184378222622061884949211758515285014A15056N85014B851502155672760B84559B227522224185163B221712215122152221752231822170222472189984971S2167321672216712167020750215572277222241848368518722361223632236421122222622216272760B8520085150825992116915056BL15056N2217622318222428497822778227752166922774824862192820713207122193137444B37444A84849D2226222620851872145647590A2231885205B35920848362138917136A84997A22284215638248322121359242117584949227732155884849D2194784912A15056BL15056N219302211222291222762082985185B2216235637A215633592185163B85099C223522193121673226452072522087359242145615056N217552167222771228052228485205B21380226372226284997A84997D20829219492241147580215638483285188A223552217184509A22772216712167285185B2072684849D84832222812277020733211662132784510A2065585188A21470211102144522090208292235215056N222412175584865213292116985071D82567214702208621121219472188320655213802226220665210352192921928224112166821754400012071922719228442072479321216692072585099B2072784946212402067521244210332193182001S85099B82482213138497821314226632241122385222812111022613220882290822805227732175515056N825832082947590A2066585071D85071A84849D224182242084563A2147072799F8248421240215232067721243212442067521239211652116637444C37444A84750B84849D2198721121211222153782613A851872228184997A226632224182583824868248372760B79321212388497822364228452224175049L4742147590A2277122805206552123922325222628248384997A223182278815056N85014A21470215592217120725219312072622355216682208717129F21080215234818721558216722167021673216692271922774227722217122170213862229121169217312262085232A21755219342228185150211692143921380220902208922088225258518782483213142131385099B2193622101207282131375049L2121848173C4818548111481162124222197714598497822087824838248622104848328494621989225258515221755213802173320829206658437821035215578258184912A2209022321224112103385188A22291359212275221389215632156422771228052208782494L218844758021563215642252120829213802246722778849782271917129F219313744621035214702116622089225232065584997A85200213892229122525225582275522758227562275322754227578494982613C2138085188A215642275822757227562275522754227532198722243826002208885205B21171224112319923201232052320422661232052320823206851972228115056P2145921212216692167122355712792195582001S85099B2277522355223562072320724223832072622382223842072520727207282241121929226632193020711223852103321928223862193120712211758515222670231822267122672226752267422673850532245715056N15056P2144784563A2227882613A206558494922637226202262021731223322233122333223342209022089220882208722908213272132922281847892101221564220872075021928219292241120750221752156484997A221622215184949208292213922457219342319923201851522117584832226202186485014B15056BL15056N2208821931223844000320676206742072775049L84755849787145922386207122241185099F85099B227782167321672216702166921668217922266321211219882279620750218992140884997D21380227662217584997A21731231402314121115217332156321564211662116482600232564758015056N15056BL21557226372213921033223852192822457849782316885099B2193020711224272238685099F21931207192071221929226612238322382207182308484997C2319223191231902316523167231662237946138B2320621559221522156346138B232062241122178219312213921929223862266385099C85099F22386207122237921175712702186747590B22766226612071923208475802238315056N207282082920726207242072322356212452124284997A84997B232052320885099F22386207122192985099C84510A2320422383232012209084509A85099C23208231992238621929207272071220718228962071923205207262072385099F2325622382207282238422139216702308415056BL2275284692227572275822756232052235620724207232072620725219292103385099F85099B8497875049L17129F8248422774227722277121314227782316815056BL15056N84849D82613D826002227884997A84997C71270712702115922663211692275221467211152143984997B84997D22891227582155784970S20829213802173122382220832111548194226612072722663207192303423035230332242722103714772238217129F82001S20685232042071923206207282319923201224112238685099B21928219312189984596B84596F2111521166215562117121163213802173115056N15056BL22083826002156484347212312208321559224112193185099C2308923084217311600882001S21137227552275621787214472204121175211792116923182211942120815056N2067921557223162319247590A211242319623197231982242622278223158505384596F2328523286232872328818097C228912235447559B47580231992266385099B17091J2257122572210332238647590A2156321557227522111082613D17091J15056N206792173123201223852316623165231632242623182226712303520829220452167322548217902267022409224072240622408224072217921980219832198522615224682198221984219672261647310M2071221137160084811185159A85159B219302071185014B82613D22671208292121120898218672275622753227582275722754227552262022139231822215121447212328248622905229042290323197162252319223190229082178747351B2238675049L223602303322426230352308921716217152277371477227732277422041217182142821672216692290816225224672066584347229052116922671231822319823196231971600885014B15056N15056BL21671216682152348187231682303484569A84569D15056BL15056N20711219302071282600207262072421669216682167121670216722310417129F2113722467824862124585099F2192922775232062238322384207271600821731231822319647310M208292113721718217152318222316227552240923166231672319823197223152231615056BL71459207331600815056N15056BL22316231822277547310M22178231672267084970L2221922139214242142623198231962319723198217542240622409219862179121790226702178721930223862319985099C226702198222409217872247648173C15056BL22755211372131347310M82001S2316822197220412231648173C15056BL15056N85099B2267523201225482318272802A2213547351B1600823198712702121021424214272142822406217182171621467231672308922315223642277817129F213137147775049L8497847351B23168231652284482001S21137160082275215056BL15056N22620217552175448173C21934226372308922409214302240722408224104748047471217312267022665221512275722756227582275322754227552319823197231962267221447208292217421428228918256782600211752267521425214272290422905229032179021791225482254916225224062171822560222972198721439218672065584997D84997C84997A84997B221392293922990214702070479302M21989217152171622134231542210148173C221782235221470216692277385099C2316723166223862071322674226752232622328223272232922410227552233322411207122193021929219342267522670226732267415056N15056BL2303123029230322302822758217872082922646226452318446118214282217922326227212236223403219282192922663207112241121930207122217322682226832268022681226842268522670226792268622677226712267222673226782267684406B2314723146231482082922427227582232684949221322213379066K2318247563A84912A221398483220655213292189921327224292194723016215312264422637221792116621867209862250085014B85014A213802275221684231842153023142228982289921523230892242715056BL21791222162179022904230361622522644226462192920711211662227822674226912269222414223652236685014A206792316921110850531622523190231922319122754226202278144089C44089A8434721327213292231822085226712290421380226282257185099B79066K2238621928475802268622685226812233122406843472266321561215592113720713233152331623317214272241023026231632189222310215302264422646232752264522757219342268321427212573592422227231972275522686226852267622671218822188022326214702303184970L2120721166211652232715056BL8434784510A208292213984509A2316822467231662316585159B217747145948184231692208385099C22411207122268622676226702267722679226812302923032227582327522409218122318221086223322233315056N15056BL16008226632193421121226802267623032221712267715056P2331622366226202231085014B2132921791213272117422326227582198721881223312227621530227562188221812218112186421866230312275722162475802233222333212574818479302M4818522678226832314715056BL2173122326232752303122677226862268023148222972290521232217902236684600215302303221811227552213917091J211372121022686226782268322682226762267722685212588460084510A23275226208434715056BL208292267421731222278494784347215582314822663215302275821012229042213921094207132246822905226792275822755230322217521530224262104184510A23147226718434715056BL21755215312263722386219342319622758222272155822904843752173122161226822267722678843472240723169224672125884947211372275522758231682327548173C849472242616008225562319722572225712213921879218832188121880226202193422426229622296322227221392314716008843478248684510A22753227572138015056BL15056N23031231462241115056N15056BL21773227572181122904229052290322227226852268222683226782267622671226772268022670226812268422686226792267222754227562275322673226752267423163160082318222310211212188384375231462186722175851502116421169851522117521530224682217921211211642198821557226204742120679220652296322962211372316823166231672238620712227782213922844219342193021929219282131375049L84945847924811182483824822266385099C224112217182001S217312143915056P21987843472206582486206852222723271223332115947559B2082923397481872181184347218922314821812220782101222227223652242623168207112179122152215302275422753227562275723317233152250072800E160082184422227231962318422310217872267421880218822192822663221792082921892843752242920712220832316922467725982222735001G211101601621949218998483684347211694811684970S2067979302M8505321012233972236547563A21470214282082923026232752238685099C224114818821169207182072485099B223278469223031213808520285204852032319784347233162331522265207132279415056BL2204121169843472278123315233162275584971S442354423444235227582275523197226912113721258224142152448116231692331523316233172179022678222622189222227217182171623184231962193185099B84347224108494523147231482240647310M79302M2290546118849782275221258233262131348187233172319721012222272279423182217558505323110211692125823168231672131421137442348434725.5434644.1444440.315508474.0419.71428626.142857
99160982005.6387.07.0613.01000221912218322241122379223812279822726229262283922838227832292622782224112091422381206812269022730227282272722381223792241122926230942241184673B84673A2188823080223812299222411227262273022727227252091423094229922241115039209148407722728227292331523316227302272522726227272272822729227272273022725224112272622726219122188884754232152321429.93477647.6666670.0243900.087.5714299.571429

Last rows

df_indexcustomer_idgross_revenuerecency_daysqtd_invoicesitemsproductsavg_ticketavg_recency_daysfrequencyqtd_returnsavg_basket_sizeavg_unique_basket_size
29595627177271060.2515.01.0645.08505321928219292358123203229962300484978849462205122986232312354616156S215232269248187235972329822169221702309323408824822299047591D2296522989224252242922426850592324323337233352319821977233072329522624226272272023245229792298022978229812298222993234952272222723229072310422557225552255622551225542337023366214302323623240217902262216.0643946.00.2857146.0645.00000066.000000
2960563717232421.522.02.0203.084347214842335622816228182369522030207772343922866207662076422867228652349423493233442214222966220812299120761215842148484347235762214423319207612324022428228652272622867227272334411.70888912.00.1538460.0101.50000018.000000
2961563817468137.0010.02.0116.0232042246021231225962107027.4000004.00.4000000.058.0000002.500000
2962564913596697.045.02.0406.02262523345233462297823580231162285121136848422296184997A22367228992327522949210802325421715224508499223256224292236023293218772197584991231732209123275232892329021972233132333822966215922295522951223262187784988210344818721975233722295122417232962357523241231772356023345226302350823313229482241722951226302262923084233062320323390234942349323343232992275422909229102290323371225512350822489218782262322549218892253022543233202328523288232862328723084225342254422556235102338922948235982256322562220932273023401221112161523307220932340923371232412319323194219132308022423218882162121878225542266222382224992339022516225172251422515217152171823372849782313022445224502244623197235292161523198224892337223371233778499184978224852209121136229562327122460221782324523239228132319022746227482317723194232412324221790233672334623368233454.1990367.00.2500000.0203.00000083.000000
29635655148931237.859.02.0799.085183A2278220749222772193122380232022245722089216422331079302M2308222780230792231021314224232289422907229082227884912B2116717084N17091J2207522580235812149722438224392218170007217902170521703229602137722467229692110884031B84032B84032A84031A2236147421850662311085183B233532349285049A2290922818224568248485152825822117521174211812190821166219072315523200231992320385099F85099B2320216.9568492.00.6666670.0399.50000036.500000
2964565912479527.2011.01.0385.021212212102108021086219892198721558212112121321882224378499222993226282121623243212172272021088219882109422215227342207785049E85049C20978209792097323370POST17.0064524.00.33333334.0385.00000031.000000
2965568014126706.137.03.0508.022274221502227322779226212245785123A209612260522433214792344420963225602096147.0753333.01.00000050.0169.3333335.000000
29665686135211093.651.03.0736.02353523301233002332022138228352211385177226512187823084851782262185039A21313219142145422620235702299323251218182181021819710502149435471D233272332621135230748497823367216842214422150218892179023189226592249484347216162162021615850592181821819221162117221905230602328121446234982342223420220912272784625A2301323014224812286322972229742332882551224022132985032A85032B85032C232932283122196210662299323293232942329521314224282218222961233682336523366235522349722196221952334023382230842259222842228402242922208222082220922211215342152821537359673596423163231622236747591D215922235222945232492325023251214942297722977210122348922071220702332022509223652277022605226072330123300219122254923526216192171384031B2067915056N229522211323356228352211122695221962295223295224242159284032B2339423396233952339321714233282353523536230892140121400233388498822190234942191422546851782318222673226712178721914210642255785231B232418505322118221192301923080848322308421718214942342222494840122329522642843752219621790219162212322942212792281122457224092240622398224002240021716224412296085061W2306023281234252241984707A22076220752247623169224742316935471D2332884947229642310123100234183597023168232952295623489226392264222638226432321421818218192181022956234952355223498234972329623293232952329421263M2250915056P20679206862217023084209922198421790235042209123376235062351022280222792295285176227272238923367225572255190214E2253022546225442254422533225342214422744227432349390214P90214I22651218782173921064207332198421705233002330122500216192308022940209722215085015150392262122500211152189121890220962275420996218942314421260213132138384993A848792113621718225222318985169A85169C85026B2249521494230742330922132220992339820986220972162085231B21976849918497822139214392267121172231882199321329235512110922119224732247422209224222339947469223982240223356221112283522113221102221022211222082144679063C22620231222163821640209752299322075220742207622481225632256222564222762207222109221082212484596B232522247523340223142293870006233682336620975225612295522472848192159121592846923597022642223432219621563221952153021977231232086821715226382264323212211622328123382231002181921810232122321521810218082180322955229562332022094229422.5083724.50.3000000.0245.333333145.333333
2967569615060303.098.04.0263.022485224562346123090214942115484876B84877B215922199135471D85049A85049E235622298223100232752308422616229522125822597227342369485049A2202822209229522226635810B2161621619216158511185183A22500233952339422654231982235822507222782103485177233782261623376233782357117012D17012B2115485049E22734225858517685183A85049A225782257723359219912220922952222082337822597225782257785111226972346123090223782346185049E233542159221080226542310023275233522335122358235702211516254M21616216152161935471D85032B223492234884877B84876B84876B2198085032C227542275520755207772234823394233952142821034224562066822456220302240223291232922349921916219912.5048761.02.0000000.065.75000030.250000
2968571512558269.967.01.0196.0227122334485099B2320979191C23392848282315821507215082202724.5418186.00.285714196.0196.00000011.000000